Calling the Row Number?

  • Thread starter Thread starter gorkyness
  • Start date Start date
G

gorkyness

I'm using the following function:

=HLOOKUP("350305",PIVOT,2,FALSE)

When I try to copy it down a column, the function doesn't change a
all, but I want the number "2" to reflect what row the function is on
Is this possible without making another column with number
1,2,3...etc
 
You must log in or register to reply here.

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

HLOOKUP - Relative cell reference in row index number 0
Hlookup-Drag to rows below 5
Find values across a row and return a text value from the same column 2
Conditional SUBTOTAL in XL210 Table 7
Excel Help to copy information from one row at a time to another sheet 1
Numbering Rows 1
convert column to a cell with formatting 3
How do i hlookup with the "row index number" changing 2

Back
Top