Auto Copy Company Name based on company ID

[savio]

Hi all,

I need to automatically copy the company name from sheet 1 to sheet 2 based on company ID.

Any help will be highly appreciated.

Thanks in advanced

 

[dnorm]

=IFERROR(VLOOKUP(Company ID,Sheet 1,2,0),"")

this will look up the cell "Company ID" in "Sheet 1" and return what ever is in column 2 .. if it is not found than you will have a blank space. So if sheet 1 has the cmpany ID in column 3 and the company name is in column 1 change the "2" to a "1" .. ect

 

[savio]

Hi dnorm,

Thank you for your reply.

In sheet 1 i have the company ID start from column A2 and the company name in column B2 .

My question In which cell/sheet should i post your code?

Thanks

 

[dnorm]

Hi Savio

This formula would go in the cell where you want the company name to appear. In case I did not make it clear enough (sorry if that is the case).

=IFERROR(VLOOKUP(Company ID,Sheet 1,2,0),"")

the IFERROR command should return a blank if no match is made in this case.
VLOOKUP will look for the matching data in another sheet.
Where "Company ID" is that is the cell with the ID number on sheet 2 for you.
"Sheet 1" is the location of your data where the information is - in your case Sheet1!A:A ... as you are only wanting to look in column A
The "2" is the column where the result you are after is (note column A would be 1, B would be 2, C would be 3 ..etc..)
The "0" is the row location, as all your information you wish to reference is on the same row we have entered a 0.

so your formula should look something like:- =IFERROR(VLOOKUP(A2,Sheet1!A:A,2,0)"")

I hope this helps!