Formula for Checking if a cell value equals another and printing the name in the cell

**Taariq** · 04-14-2020, 02:08 PM

Good day Everyone,

I was hoping someone could help me out with the following:

i have two tables:
the first table has ID values and the name of those ID values
the second table only has some of the ID values from the first table

I would like to know if there is a formula i could you that would allow me to search through all the ID in the first table and if it matches with the second table to print out the name of the item.

I have tried AND statements with Multiply IF statements but im at the point of writing 1000+ if statements in order for it to show all the ID values.

if i was not clear about the question please let me know.

I have attached a sheet below:

**Sam Capricci** · 04-14-2020, 02:27 PM

try the vlookup ... =VLOOKUP(A2,'First Table'!A:B,2,FALSE)
and drag down.

**Taariq** · 04-14-2020, 03:30 PM

Hi Sambo thanks so much solve my issue and saved me years !!!!!!!!

do you have a youtube tutorial on Vlookup ? or know of any good ones

**Sam Capricci** · 04-14-2020, 03:56 PM

you can probably just search on vlookup, there are a lot of videos out there on it.
but it essentially works like this...
=VLOOKUP(A2,'First Table'!A:B,2,FALSE) is doing a Vertical lookup (the V part of Vlookup)
where it is looking for A2 in the range set (in this case from) column A. When it finds the value anywhere in column A it then looks into column B to return the value there (that is what the 2 is for).
You can also look up items in the same column just to verify they are there like =VLOOKUP(A2,'First Table'!A:A,1,FALSE)
The last part, FALSE means to return exact value when found. If that was changed to TRUE it then returns approximate values but the table used 'First Table'!A:B,2,TRUE should then be in ascending order. You would use that for looking up inexact values.
For instance you are looking up 1.05 but your table has 1 then 2 and what is beside the 1 is A and 2 is B, it would return the A because it isn't an exact match.
Some people put =VLOOKUP(A2,'First Table'!A:B,2,0) instead of FALSE or =VLOOKUP(A2,'First Table'!A:B,2,1) instead of TRUE and the formula will work the same for either of those.
For a VLOOKUP the value you are looking up can be in any column BUT you have to remember that the returned value HAS TO BE in a column to its right, if you have a value in cell A2 but where you are looking for its corresponding values in another area but the match is in column D of that tab and the value you want to have returned is in column B then you use an index/match, like...
=INDEX(Sheet2!B:B,MATCH(A2,Sheet2!D:D,0))
Hope that helps.

Formula for Checking if a cell value equals another and printing the name in the cell

LinkBack

Thread Tools

Rate This Thread

Display

Formula for Checking if a cell value equals another and printing the name in the cell

Re: Formula for Checking if a cell value equals another and printing the name in the cell

Re: Formula for Checking if a cell value equals another and printing the name in the cell

Re: Formula for Checking if a cell value equals another and printing the name in the cell

Thread Information

Users Browsing this Thread

Similar Threads

Formula - If a cell equals any cell in another column then...

Make Cell BLANK if own cell formula equals ZERO

[SOLVED] If Formula (IF this condition is met, then adjacent cell equals above cell)

[SOLVED] IF/AND Formula in a cell, cross checking other cells then displaying them in another cell

IF formula required ( i think) one cell equals another cell, then give value of another.

[SOLVED] Need a formula that returns a the content from a cell if another cell equals yes

checking if one cell equals another in another sheet

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions