Vlookup for two values instead of one

[Karnik]

Hello Experts,

I use following Vlookup for one value in cell Q10.
Is it possible to look for two different values and give out put in concatenate?

VLOOKUP(Q10,$CA$2:$CB$6,2,FALSE)
Thanks
Karnik

[jayinthe813]

This is a way to look up two different values, but wont give a concatenate. I don't think vlookup alone is going to be able to do that. Maybe this could help you in your quest, or give someone else an idea:

=INDEX($K$1:$K$100,MATCH(c874&g874,INDEX($A$1:$A$100&$G$1:$G$100,0),0))

[MarvinP]

Perhaps
VLOOKUP(Q10,$CA$2:$CB$6,2,FALSE) & VLOOKUP(Q11,$CA$2:$CB$6,2,FALSE)

[coreytroy]

Can you not use the 'IF' 'AND' formulas ?

Small words but have big meanings

[jayinthe813]

Can you not use the 'IF' 'AND' formulas ?

Small words but have big meanings

I had thought about that application, but these generally return to either TRUE or FALSE based on conditions, not really concatenating two formulas

[coreytroy]

Personally i find them almost unlimited in possibilities.

Please Login or Register  to view this content.

alt.

Please Login or Register  to view this content.

[Karnik]

Hello jayinthe81 and coreytroy,
Thanks for suggestions, I have tried in test sheet and not come up to results, I perhaps need to work modify as suggested and try again.
I appreciate your time,efforts valuable suggestions.
Cheers
Karnik

[msnandi]

I'm sorry but I couldn't figure out how to create a new question so I'm replying to this since it was posted today. I really need help with excel. I'm not sure how to ask this question but essentially, I have two spreadsheets that reflect the same data (site ID) in column B. I know this because I did a vlookup....yes, some of this data doesn't ALL match (#N/A) but that's not a big deal. One of the speadsheets has additional information in column T that I would like copied to the other spreadsheet into column F. I'm thinking there is an IF command for this but I can't figure it out. I was shown how to do this before but didn't take notes and can't remember. I think one of the functions required me to count the cell column (i.e. T20 since it is the 20th letter of the alphabet). I want to take the information from column T if it equals zero ($0.00) and copy it to the other spreadsheet and associate it to the applicable Site ID.
Can anyone help?