Lookup Formula Question

[floggingmolly]

I have a workbook with 2 sheets. On Sheet1 I have in column G a list of Station Numbers. On Sheet 2 I have Station #'s in Column A and Column B, then in E there is a due date. I am trying to figure out a formula that will look for a certain # on sheet 2 in column A and B, then return the date in column E. Not sure if that makes sense. For Example: On Sheet 1 in column G I have station #200. On Sheet 2 that # might be in Column A or B depending on their location, so I need to somehow do a lookup in A and B to find #200, then give me the corresponding date from column E. If anyone could help it would be greatly appreciated. I have been trying for 3 days and can't get it to work.

 

[etaf]

could the number be in both a and b
you could use a vlookup() with an iferror()

iferror(vlookup(lookup in A), vlookup(lookup in b))

 

[floggingmolly]

could the number be in both a and b
you could use a vlookup() with an iferror()

iferror(vlookup(lookup in A), vlookup(lookup in b))

That worked perfect. Thank you so much. Is it still possible to hide N/A if the # is in neither column? I tried doing the "" in the formulas but didnt seem to work

 

[etaf]

i think embedding another iferror
iferror(vlookup(lookup in A), iferror(vlookup(lookup in b),""))

 

[floggingmolly]

i think embedding another iferror
iferror(vlookup(lookup in A), iferror(vlookup(lookup in b),""))

That did the trick. Thank you so much for your help. Much appreciated.

 

[etaf]

you are welcome