# Index/Match or Vlookup

1. ## Index/Match or Vlookup

I would like a formula that will pull the Loft Prices on each sheet. In the example workbook 'Sheet1' is where I will be pulling the information. In cell A3 I would like to be able to put the name of the sheet and then in B3 the formula will pull the Loft Price for that sheet.

2. ## Re: Index/Match or Vlookup

Try

=VLOOKUP(\$B\$2,INDIRECT("'"&A3&"'!A:B"),2,FALSE)

Note, on sheet3, "Loft Prices" does not exist, instead it only has "Loft Price"
Consistency is important with this type of function.

3. ## Re: Index/Match or Vlookup

In Sheet 3, you are missing a S. But in B3, enter =VLOOKUP(\$B\$2,INDIRECT(A3&"!A:B"),2,0) then fill the formula.

4. ## Re: Index/Match or Vlookup

Try this:

``Please Login or Register  to view this content.``
EDIT: Oops... took too long hehe

5. ## Re: Index/Match or Vlookup

Thank you guys! I knew I had to use the indirect formula in it but I kept messing it up! Much appreciated!

6. ## Re: Index/Match or Vlookup

Try

=IFERROR(INDEX(INDIRECT("'"&A3&"'!B:B"),MATCH(\$B\$2,INDIRECT("'"&A3&"'!A:A"),0)),"")

7. ## Re: Index/Match or Vlookup

You're welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1