Vlookup/hlookup assistance

[Hollyb1987]

I want to be able to type in a number in cell D29 (which is a number found in row B), then enter a number in cell D30 (which is a number or text from row 3), and the corresponding number from the Range B4:M26 will populate cell D31 The example shows a "3" in cell D29(which is the pipe size) and an "80" in cell D30 (which is the pipe schedule) and the number in D31 is from the table.

http://www.excelforum.com/showthread...92#post4564592

[FDibbins]

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

[Kamal Asharaf]

Please find attatched sheet with formula -

VLOOKUP(D29,$B$3:$H$26,(MATCH(D30,D3:M3,0)+2),0)

[JeteMc]

Kamal's formula will work well for pipe schedules up to 80, however to include the rest of the schedules (through XXS) I would suggest modifying the formula so that it reads:

Please Login or Register  to view this content.

Let us know if you have any questions.