Weird Formula

Mar 5th, 2002, 09:39 PM

I have a table
ID Name
-----------
1 AAA
2 BBB

How do I write a formula such that

When I enter ID in cell A1, cell A2 will be written with the appropriate name, or "Not Available" if the name is not available

A2 = "=IF (A1........

Thanks

Mar 5th, 2002, 10:46 PM

Say your table is in the range F1:G10
In A2, enter
=IF(ISNA(VLOOKUP(A1,F1:G10,2,FALSE)),"Not Available",VLOOKUP(A1,F1:G10,2,FALSE))
HTH
Richard

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 09:39 PM	#1
Guest Posts: n/a	I have a table ID Name ----------- 1 AAA 2 BBB How do I write a formula such that When I enter ID in cell A1, cell A2 will be written with the appropriate name, or "Not Available" if the name is not available A2 = "=IF (A1........ Thanks

Mar 5th, 2002, 10:46 PM	#2
Guest Posts: n/a	Say your table is in the range F1:G10 In A2, enter =IF(ISNA(VLOOKUP(A1,F1:G10,2,FALSE)),"Not Available",VLOOKUP(A1,F1:G10,2,FALSE)) HTH Richard