Vlookup on two columns not using concatenate

[cranebill]

I have 2 spreadsheets.

Sheet 1 is a user entered sheet. Sheet B is a lookup sheet linked to a DB backend.


I need to use column A and B From Sheet 1 and compare to column A and B From Sheet 2 and populate column C through whatever on sheet 1.

How does one accomplish this?

 

[AnotherHiggins]

Why not concatenate?

In the sheet containing lookup values, use a helper column to comine the values of columns A&B, then your formula do the concatenation for the other sheet ( Vlookup(A2&B2,... ).

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[cranebill]

The reason being that the second sheet will be populated by a DB backend or some sort of import. If I personally would be the only person using this sheet, then it would not be an issue however i am trying to make this as idiot proof as possible

 

[SkipVought]

Why the cryptic description?

Please give a cogent example of what's in each sheet and what you expect the resutl to be.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}