Tech Support Guy banner
Status
Not open for further replies.

How to Add Two VLookup in One Cell

836 views 1 reply 2 participants last post by  etaf 
#1 ·
Hi Guys ,

I am new to this Forum. while i searched in google to find my answer that time i got this forum.
I think finally this is my destination. Any how come to my question.
Adding 2 values in one cell using vlookup because i am having 2 spreadsheet how to take the 2 datas in one cell.
Here i shows what i am using.
=vlookup(B2,Shhet1$B$1:$I$1250,10,0),vlookup(B2,Sheet2$B$1:$I$1250,10,0)
result: #Value
Please guide me guys i beg you. because this is my big issue.
I am eagerly waiting reply
 
#2 ·
use
=vlookup(B2,Shhet1$B$1:$I$1250,10,0)&" "&vlookup(B2,Sheet2$B$1:$I$1250,10,0)

if that is not what you need
Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top