Vlookup Un-concatenated Values?

[Jtucker10278]

I apologize, i don't know how to cleaning ask this question or I would probably be able to find the solution on my one

 

[Joe4]

I don't think there is very much we can do from that description, as it provides no detail at all.
Maybe it would be better if you should us an example of your data and expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Jtucker10278]

(i cant even use this forum correctly, my brain is just not on today)

what I have is giant spread sheet with lots of data and the left 2 columns are

Jobnumber Release number

24035 R1
24035 R2
22051 R7

etc etc

how can i VLOOKUP both values to get data from that line without adding a column and concatenating them

something like
VLOOKUP(A26&B26,PanelStatus!A18:M42,5,FALSE)

 

[Joe4]

Jobnumber Release number

24035 R1
24035 R2
22051 R7

Is this the range of values you are looking up, or the structure of the range that you are looking into for a match?
Please show us the structure of BOTH sides.

 

[Jtucker10278]

The sheet I am looking at to pull data from is set up like this (also I cannot add a concatenated column to this sheet as it auto updates every 15 min and needs to stay as is)

A	B	C	D	E	F
Job #	Release #	Pnl Qty	Pnl Cut Qty	Pnl Asm Qty	Pnl Pack qty
21053	R1	138	107	56	40
21053	R7	254	254	254	253
23008	R16	44	0	0

Then i have my sheet that i want to put the information that i have looked up. but I can structure that however i need or want to as i will enter the job and Release number manually t get the information i want to see.

A	B	C	D	E
Job#	Release #	Concatenated Job/R#	pnlqty	pnl pack qty
21053	R1	21053R1	138	40
23008	R16	23008R16	44	0

the main sheet has probably 150 rows and 40 Columns of data
but I only need to look at the data for about 5 to 10 job/R#s at a time and less than half of columns but its a pain to sort and filter through so much, hoping to find a way to pull the data
thanks for the help

 

[Joe4]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’).

There are two methods shown here. The XLOOKUP, if you have Excel 365, is probably the easier way to go!

Two-column Lookup in Excel

This example teaches you how to perform a two-column lookup in Excel. We want to look up the salary of James Clark, not James Smith, not James Anderson.

www.excel-easy.com