Hlookup Query

[PrashantJP]

Hi Team,

Can someone please help me with the below solution?

There are 3 sheets in the attached excel file. Data 1, Data 2, Output in Data 2.

I want to process information from Data 1 and Data 2 and the output should be in Data 2 sheet as indicated in "Output in Data 2" sheet. Thanks in advance!

[mceleavey · Accepted solution]

Hi @PrashantJP ,

this was achieved by a bit of transpose magic:

Workflow attached.

I hope this helps.

M.

[Jonathan-Sherman]

Hi @PrashantJP,

You could achieve a HLOOKUP equivalent with a transpose and join:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

[atcodedog05]

Hi @PrashantJP 

Here is a workflow for the task.

1. Using sample tool to get last row.

2. Using transpose tool to convert rows to columns.

3. Using Find & Replace to do a Vlookup. Link 

Hope this helps 🙂

[PrashantJP]

Thanks a ton @mceleavey

[mceleavey]