Hello all,
I have a list of values in column A of workbook Joe.
In workbook Bloggs, i have a portion of the values of column A workbook Joe in column A of workbook Bloggs. I now want to find where value in column A in workbook 1 matches a value column A of workbook bloggs return the value of column C.
I was using vlookup(A2, bloggsA:C,3,0) but only got true or false, where the actual value in Bloggs C2 = Thanks, how can i get vlookup or alternative to return the actual value of C2
Is that you're "actual" formula?Originally Posted by brian_2me
Replace the 0 with FALSE.
bloggs looks incorrect and shouldn't work as it is.
you can send a sample of your excel to help us understand better what result you need
brian_2me,
If you are not familiar with how to attach a file:
To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),
- be sure to desensitize the data
- click “Go Advanced” (next to Post Quick Reply – bottom right),
- scroll down until you see “Manage Attachments”, click that,
- click “Browse”.
- select your file(s)
- click “Upload”
- click “Close window”
- click “Submit Reply”
The file name will appear at the bottom of your reply.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks