Lookup and Return

[HNoel33]

Afternoon, I am having a difficult time that seems should be easy. I have 2 spreadsheets. Sheet One has data I am looking up to see if it can be found on sheet 2 ; with that, I would like the formula to return the text Yes or No. But , when I am doing this, I am catching that it is not accounting for all the data. Example: it will say no - I will look up that IP as a double check, and I will find that IP address on Sheet two. (so okay , maybe it is the IP Address ,,, lets look up th host name )
So I did that; same result.

How do I get a formula or statement to bring back whether or not the data was provided on sheet 2? (without lying)

Sincerely, Hns

[6StringJazzer]

Suppose you have a value in cell A1 of Sheet One. You want to see if that is in column B of sheet 2.

=IF(ISERROR(MATCH(A1,'sheet 2'!B:B,0)),"No","Yes")

If that doesn't work please attach a file with sample data. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

[Richard Buttrey]

Hi

Please Login or Register  to view this content.

is the generally recognised way of identofying a match. It returns the row number of the item being looked up in the sheet being looked at.
#N/A wil mean no match.

To get a yes or no wrap it in an IF test

Please Login or Register  to view this content.