Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula's
Is there any way to combine the VLOOKUP and IF Statement formula's into one
formula or is there any other kind of formula which does both???? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula's
You can certainly combine VLOOKUP and IF. What exactly are you
trying to do? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "George" wrote in message ... Is there any way to combine the VLOOKUP and IF Statement formula's into one formula or is there any other kind of formula which does both???? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula's
Is this something like what you're looking for?
=IF(A1=1998,VLOOKUP(A1,YourLookupTableA,2,False),V LOOKUP(A1,YourLookupTableB,2,False) Vaya con Dios, Chuck, CABGx3 "George" wrote: Is there any way to combine the VLOOKUP and IF Statement formula's into one formula or is there any other kind of formula which does both???? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula's
i need to look up a reference number on a seperate sheet in excel. I then
want to add a formula like this: IF(AZ=0,BB,AZ) How would I put this inside a VLOOKUP Formula. I tried this: =VLOOKUP(b16,fast,IF(AZ=0,BB,AZ),false) Any suggestions. "Chip Pearson" wrote: You can certainly combine VLOOKUP and IF. What exactly are you trying to do? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "George" wrote in message ... Is there any way to combine the VLOOKUP and IF Statement formula's into one formula or is there any other kind of formula which does both???? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula's
no, I need to VLOOKUP of for example 1998 but i would want to record the
higher of two values. So if 1998 is my reference field and let say age is what i'm looking for I want to pick one over the other base on a criteria in the if statement. Is this possible. "CLR" wrote: Is this something like what you're looking for? =IF(A1=1998,VLOOKUP(A1,YourLookupTableA,2,False),V LOOKUP(A1,YourLookupTableB,2,False) Vaya con Dios, Chuck, CABGx3 "George" wrote: Is there any way to combine the VLOOKUP and IF Statement formula's into one formula or is there any other kind of formula which does both???? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula's
Just use a normal VLOOKUP, like this
=VLOOKUP(B1,FAST,2,FALSE) Then, in the FAST table, in the cell just to the right of the value found in B1, put your IF formula........ =IF(AZ=0,BB,AZ) Vaya con Dios, Chuck, CABGx3 "George" wrote: i need to look up a reference number on a seperate sheet in excel. I then want to add a formula like this: IF(AZ=0,BB,AZ) How would I put this inside a VLOOKUP Formula. I tried this: =VLOOKUP(b16,fast,IF(AZ=0,BB,AZ),false) Any suggestions. "Chip Pearson" wrote: You can certainly combine VLOOKUP and IF. What exactly are you trying to do? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "George" wrote in message ... Is there any way to combine the VLOOKUP and IF Statement formula's into one formula or is there any other kind of formula which does both???? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula's
I need the If Statement to be inside the VLOOKUP. Is this possible.
"CLR" wrote: Is this something like what you're looking for? =IF(A1=1998,VLOOKUP(A1,YourLookupTableA,2,False),V LOOKUP(A1,YourLookupTableB,2,False) Vaya con Dios, Chuck, CABGx3 "George" wrote: Is there any way to combine the VLOOKUP and IF Statement formula's into one formula or is there any other kind of formula which does both???? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula's
Check out my "other" post.......it effectively does just that........try
it.........it will return either BB or AZ depending onthe value in AZ, just as your IF formula specifies. ********************************************** Just use a normal VLOOKUP, like this =VLOOKUP(B1,FAST,2,FALSE) Then, in the FAST table, in the cell just to the right of the value found in B1, put your IF formula........ =IF(AZ=0,BB,AZ) ************************************************** * Vaya con Dios, Chuck, CABGx3 "George" wrote: I need the If Statement to be inside the VLOOKUP. Is this possible. "CLR" wrote: Is this something like what you're looking for? =IF(A1=1998,VLOOKUP(A1,YourLookupTableA,2,False),V LOOKUP(A1,YourLookupTableB,2,False) Vaya con Dios, Chuck, CABGx3 "George" wrote: Is there any way to combine the VLOOKUP and IF Statement formula's into one formula or is there any other kind of formula which does both???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif formulas change after doing a sort | Excel Worksheet Functions | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |