Microsoft Excel Meeda Grip Unnavaallu Randi - Urgent Help Needed

[deals2buy]

naa daggara oka Excel sheet undi...which is built of using some macros

andulo VLOOKUP ane function vaadaaru...asalu adi em chestado koddiga exact ga cheppandi

Online lo chuste em ardham kaaledu

aa query something like ila undi vayya

select '=VLOOKUP("ORG FAILED CLUSTER",''FAILURE CODES''!D3:G56,4,FALSE)'


endo deeni ardham jara cheppandi

[minnu]

vlookup functionality is used for extracting a value from a range based on a key..

vlookup ki four input parameters pampali:

First one is the Lookup Value based on which you want to lookup in the range of data
Second one is the name of the range (which is a group of cells) in the excel sheet which contains the data being looked up
Third one is the column in the range being referenced whose value should be returned
Fourth one is a TRUE or FALSE which says whether to lookup the value mentioned in the First Parameter with exact match or approximate match

[minnu]

For example:

Name Class Section
Stud1 9 A
Stud2 10 B
Stud3 8 C

Paina data if it exists in Columns A, B and C.. You need to highlight all those cells and give it a name (Example: ClassRange).

If we want to lookup the class for Stud1, we write the following VLOOKUP

=VLOOKUP("Stud1", "ClassRange", 2, FALSE)

[chelsea]

Help

[deals2buy]

[quote name='minnu' timestamp='1355249105' post='1302931929']
For example:

Name Class Section
Stud1 9 A
Stud2 10 B
Stud3 8 C

Paina data if it exists in Columns A, B and C.. You need to highlight all those cells and give it a name (Example: ClassRange).

If we want to lookup the class for Stud1, we write the following VLOOKUP

=VLOOKUP("Stud1", "ClassRange", 2, FALSE)
[/quote]



but did u see my above query? It has 5 values...not 4

[minnu]

[quote name='deals2buy' timestamp='1355249842' post='1302932107']



but did u see my above query? It has 5 values...not 4
[/quote]

[color=#282828][font=helvetica, arial, sans-serif]In VLOOKUP("ORG FAILED CLUSTER",''FAILURE CODES''!D3:G56,4,FALSE)' formula:[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]ORG FAILED CLUSTER - First Parameter which is the Lookup Value[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]FAILURE CODES''!D3:G56 - Second Parameter which is saying the range being looked up is D3 to G56 in FAILURE CODES worksheet[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]4 - Third parameter which is asking excel to display the fourth column for the matched record in the range mentioned above[/font][/color]
[font="helvetica, arial, sans-serif"][color="#282828"]FALSE - Fourth parameter mentioning excel to do an EXACT match[/color][/font]

[vikuba]

two columns
col1 col2
1 2
2 1
2 2

ila unaaya anko...
vlookup will check for values in col1 if present in entire col2 and vice versa and gives out a value at cell locations.

[deals2buy]

[quote name='minnu' timestamp='1355250012' post='1302932136']

[color=#282828][font=helvetica, arial, sans-serif]In VLOOKUP("ORG FAILED CLUSTER",''FAILURE CODES''!D3:G56,4,FALSE)' formula:[/font][/color]

[color=#282828][font=helvetica, arial, sans-serif]ORG FAILED CLUSTER - First Parameter which is the Lookup Value[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]FAILURE CODES''!D3:G56 - Second Parameter which is saying the range being looked up is D3 to G56 in FAILURE CODES worksheet[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif]4 - Third parameter which is asking excel to display the fourth column for the matched record in the range mentioned above[/font][/color]
[font=helvetica, arial, sans-serif][color=#282828]FALSE - Fourth parameter mentioning excel to do an EXACT match[/color][/font]
[/quote][img]http://www.manadb.com/Smileys/default/ijilll.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img][img]http://www.manadb.com/Smileys/default/you_rock.gif[/img]
[quote name='Aamphat' timestamp='1355250535' post='1302932215']
two columns
col1 col2
1 2
2 1
2 2

ila unaaya anko...
vlookup will check for values in col1 if present in entire col2 and vice versa and gives out a value at cell locations.
[/quote]

got it...