Index & Match with columns

P

Peter Atherton

Brian
In sheet1 type =Sheet2!B83

Copy the formula accros the columns

Regards
Peter
 
D

Dan E

Good answer, Straight, to the point, not to complicated! I was wondering why he needed a lookup???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Index/match across multiple columns? 16
Index and Match 5
Insert Index into a Table 1
Index Match QUestion 0
Matching Rows with Multiple Columns in Two Worksheets 0
Can you display entire rows that match a certain criteria... 1
Match Copy/Paste Macro almost there 0

Top