D
D Van
Is it possible to nest together a lookup. I have it now where I lookup a random number in a table and it provides a value, numbers 2 and 12 require another lookup in another spot in the table. Not quite sure how to do that
I have this, so I can recognize a 2 or 12, do I just add another lookup to the "true criteria" (where the word "Lookup" is?
=IF(VLOOKUP($I2,Charts!$A$3:$C$13,2,TRUE)="II","Lookup","OK"
Am I headed in the right direction. Please advise
Thanks
Dou
I have this, so I can recognize a 2 or 12, do I just add another lookup to the "true criteria" (where the word "Lookup" is?
=IF(VLOOKUP($I2,Charts!$A$3:$C$13,2,TRUE)="II","Lookup","OK"
Am I headed in the right direction. Please advise
Thanks
Dou