Return a cell value from different sheet if the first condition is met

[mymachix]

Hi,

I have two sheets; "Summary" and sheet "SiteInfo", Sheet Summary contains column A and column B. Column A has data on rows (Honda, Toyota, Kia, etc). In Siteinfo sheet, there's two column; A and B. Column A has the random data of (Honda, Toyota, Kia, etc), Column B has corresponding value depends on column A. Sample is,

Summary Sheet

ColumnA__________ColumnB
Honda____________
Toyota___________
Kia_______________


SiteInfo Sheet

ColumnA_________ColumnB
Honda___________miller
Toyota__________google
Kia_____________concrete


Requirement is, in Summary sheet column B, i want a formula that will lookup in Siteinfo sheet Column A and if there's a match, return the value in columnB <siteinfo sheet> to summary sheet column B

Can you help me please? its been 3 days and cant find a working formula

[XOR LX]

Hi,

Is there a possibility that you could attach a sample workbook?

It's just that, otherwise, readers of this thread will (generally) have to reconstruct the information you have given in their own spreadsheets so as to test potential solutions. And obviously this is not something that everyone is prepared to do.

Regards

[ajryan88]

Hi,

Try this on cell B2 on the "Summary" sheet:

=INDEX('SiteInfo'!B:B,MATCH(A2,'SiteInfo'!A:A,0))

or

=VLOOKUP(A2,'SiteInfo'!A:B,2,FALSE)

Hope this helps

[JOHN H. DAVIS]

Another;

=VLOOKUP(A2,SiteInfo!$A$2:$B$100,2,FALSE)

[mymachix]

Hello,

This seems to work. but when i try it to another scenario wherein the data i need is not on column B but in column D and i change the formula to =VLOOKUP(A2,SiteInfo!$A$2:$B$100,4,FALSE) it returns an error #REF!. Meaning the data that should return is on column D of SiteInfo sheet.

any idea?

thanks a lot

[JOHN H. DAVIS]

Another;

=VLOOKUP(A2,SiteInfo!$A$2:$B$100,2,FALSE)

You'll need to change your Range:

to:

=VLOOKUP(A2,SiteInfo!$A$2:$D$100,4,FALSE)

[mymachix]

Attached the actual file

[ajryan88]

Hi,

You just need to adjust the lookup range to include column D:

=VLOOKUP(A2,SiteInfo!$A$2:$D$100,4,FALSE)

Hope this helps

[mymachix]

hahaha got it now finally!!!!!!! yes!!!!!!!! thanks a lot guys!!!! woooooooooooo!!!

[ajryan88]

No problems!

Please don't forget to mark this thread as solved