Weird Formula

[Guest]

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

 

[Guest]

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