Need help creating Vlookup formula for invoices ( or any other method)

[BeanyBaby]

I need help, I have been trying to think of ways to make Vlookup work with the data I need, I exported my data and it was not anything I deal with traditionally. Please give me your thoughts on how to pull data from looking up invoice numbers. For example:


(fig 1)
(enter invoice #) (display entire row)
(display bottom row)


Invoice...........Name............................RM....................Amount

123..............Doe, John RM 5................10....................... 99
...........................Royalty LLC (99)


456..............Jane, Mary RM 6...............8.........................89
............................Mobile Co........................................ (89)

(dost are just to line up where I want the data to be, ignore)


What I need is to display both rows using vlookup or any way possible. I tried to google other peoples ideas but I found nothing yet. What I was thinking of trying to do is (refer to fig 1) display the row of the invoice # and the row below the invoice number upon request.

Is there a way to lock cells? So i can sort only the invoice number and the row below the invoice number will be in a fixed position? Thanks in advance.

[jeffreybrown]

We would love to help you with your query, but first, before we can proceed, please see our Forum Rules #1 about proper thread titles and adjust accordingly...

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

[apembo]

BeanyBaby

Your post seems to be missing an attachment or figure. Can you attach an example spreadsheet?

[BeanyBaby]

Creating one now.

[BeanyBaby]

I will give hugs and kisses to someone that can help me

[vlady]

is this what you want??

EFSAM.xlsx

[dredwolf]

See if this is going in the right direction for you - BeanyBaby.sol1.xlsx

if you change the invoice number in the yellow cell, the information to the right changes ..

Hope this helps

[dredwolf]

@ vlady
looks like we both had same basic idea, lol

[vlady]

lol, yup a difference of match/vlookup but same logical approach.

[BeanyBaby]

OMG PERFECT! hugs and kisses for everyone! I am so happy thanks all

I still got lots to learn

[dredwolf]

You are welcome